Search TipsInvoice Detail
Data is only considered up to midnight of the previous day. This is to ensure a common cut-off date across all Data Warehouse output.
|
Column Heading |
Unique? |
Type |
Length |
Details |
|---|---|---|---|---|
|
InvoiceNumber |
Y |
Numeric |
8,0 |
CMP Invoice Number |
|
Invoice TaxDate |
|
Numeric |
7 |
Invoice date for the invoice the invoice detail line is associated with |
| Statement Number | Numeric | 8,0 | The CMP ID number for the statement associated with this invoice | |
|
AccountNumber |
|
Numeric |
8,0 |
CMP Account Number |
|
TariffCode |
|
Alphanumeric |
6,0 |
CMP Tariff Code associated with the subscription |
| TariffDescription | Alphanumeric | 30,0 | Text description of the Tariff Code associated with the subscription | |
|
Servicecode |
|
Alphanumeric |
6 |
Service Code |
|
ServiceDescription |
|
Alphanumeric |
30 |
CMP Service Description |
| Service Category Code | Alphanumeric | 1 |
The category code for the service: A= Unit B = Sales Ledger D = Subscription Serial Number E = Invoice Adjustments T =Account Service 5 = Subscription Service 9 = Discount F = Sales Order Processing |
|
| Service Category Description | Alphanumeric | 30,0 | The text description of the service category as represented by the category code above | |
| Sales Ledger Adjustment | Alphanumeric | Yes or No | Whether there is a Sales Ledger Adjustment | |
|
SubscriptionNumber |
|
Numeric |
8,0 |
Subscription Number |
|
NetworkCode |
|
Alphanumeric |
6 |
Network relating to Service Code |
| NetworkDescription |
Alphanumeric |
30 |
CMP Network Description |
|
|
TotalNumberofCalls |
|
Numeric |
5,0 |
Number of Calls Invoiced |
|
TotalDuration |
|
Numeric |
9,0 |
Duration of Calls Invoiced |
|
TotalServiceUnits |
|
Numeric |
11,0 |
Number of units Invoiced |
|
IdChargeStartDate |
|
Numeric |
7,0 |
Service Charge Start Date YYYY-MM-DD format |
|
IdChargeEndDate |
|
Numeric |
7,0 |
Service Charge End Date YYYY-MM-DD format |
|
IDNetAmount |
|
Numeric |
11,2 |
Net Amount of Invoice Line, positive or negative |
|
IDTaxAmount |
|
Numeric |
13,4 |
VAT Amount of Invoice Line, positive or negative |
|
ChargeTaxCode |
|
Alphanumeric |
10 |
Charged Tax Code |
| Charge TaxDescription |
Alphanumeric |
30 |
CMP Description of Charge Tax Code |
|
|
taxRate |
|
Numeric |
5,2 |
Charged Tax Rate |
|
ChargetoNominal Code |
|
Alphanumeric |
29 |
Nominal Code |
|
ChargetoNominal Description |
|
Alphanumeric |
30 |
Description associated with the Charge to Nominal Code |
|
IDLineComment1 |
|
Alphanumeric |
78 |
Free text field 1 |
| IDLineComment2 |
|
Alphanumeric |
78 |
Free text field 2 |
| IDLineComment3 |
|
Alphanumeric |
78 |
Free text field 3 |
|
PaymentType |
|
Alphanumeric |
6 |
Code identifying the payment type the customer was on at the time of the invoice |
|
PaymentTypeDescription |
Alphanumeric |
30 |
Description of the payment type the customer was on at the time of the invoice | |
|
DateTimeCreated |
|
Numeric |
7,0 |
Date Invoice Created in CMP YYYY-MM-DD HH:MM:SS format |
|
DateTimeChanged |
|
Numeric |
7,0 |
Date record changed in CMP. YYYY-MM-DD HH:MM:SS format |
|
CreatedbyDISEUserID |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
ChangedByDISEUserID |
|
Alphanumeric |
10 |
User ID of user who created the record |
|
DateExtractDate |
|
Numeric |
7,0 |
Date that the data above was extracted from CMP. YYYY-MM-DD format |